﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using BE;

namespace DAL
{
    class RoomDAL
    {
        static private BellevueEntity createEntity()
        {
            return new BellevueEntity();
        }

        public static void AddRoom(Rooms room)
        {

        }


        public static Rooms GetRoom(int id)
        {
            BellevueEntity Belle = createEntity();

            var room = from r in Belle.Rooms
                       where r.ID == id
                       select r;
            return room.Single();
        }

        public static List<Rooms> GetAllRooms()
        {
            BellevueEntity Belle = createEntity();
            IEnumerable<Rooms> rooms = from r in Belle.Rooms
                                       select r;
            return rooms.ToList();
        }

        public static void EditRoom(Rooms room)
        {

        }

        public static void DeleteRoom(int id)
        {

        }

        //public static List<Rooms> GetLocationLessRooms()
        //{

        //}
    }
}
